Data Analysis and Visualisation with Microsoft Excel - Pro (3 days)

This intensive 3 days, hands-on Data Analysis and Visualisation with Excel Advanced course takes you from beginner to advance level and helps you gain comprehensive, practical understanding of Data Analysis using Excel.

Analysing data to find issues, insights, and opportunities is now a critical part of many job roles. Beyond the analysis, data analysts in all job roles must be able to effectively present and communicate their findings in visually compelling ways.

You will gain a solid understanding of Data Analysis tools to help you organise, manipulate, and report on large amount of data in the best way possible, including connecting to a wide range of data sources, perform robust data analysis, create divers and robust data-backed visualisations to show insight and trends, and create reports.

You can choose either our Classroom training at one of our venues or Live, Instructor-led Virtual training from the comfort of your home.

.

Benefits of Studying Data Analysis and Visualisation with Excel Advanced with Infero Training:

• Classroom training in Small Groups for Max Focus
• Only Microsoft Approved Courseware and Exercise Files are used
• Free Assessment of Skills prior to booking
• Certificate of Completion & Complementary 12 Months Post Course Support
• Premier Locations, Latest Tech, Refreshments, OR We Come to You
• 100% Money Back Guarantee & Price Match Guarantee
• Bespoke Courses & Group Discounts from £89 per person

.

Data Analysis and Visualisation with Excel Advanced Certification

Upon completion of the Data Analysis and Visualisation with Excel Advanced course, you will receive a Certificate of Completion.

This course is also one of a series of courses that addresses Microsoft Certified Application Specialist (Microsoft Business Certification) skill sets. The Microsoft Certified Application Specialist program is for individuals who use Microsoft's business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more proficiency exams in order to earn Microsoft Certified Application Specialist certification.

Data Analysis and Visualisation with Excel Advanced Course Content

• Lesson 1: Data Analysis Fundamentals

Topic A: Introduction to Data Science
Topic B: Create and Modify Tables
Topic C: Sort and Filter Data

• Lesson 2: Visualising Data with Excel

Topic A: Visualise Data with Charts
Topic B: Modify and Format Charts

• Lesson 3: Analysing Data with Formulas and Functions

Topic A: Analyse Data with Formulas and Named Ranges
Topic B: Analyse Data with Functions

• Lesson 4: Analysing Data with PivotTables

Topic A: Create a PivotTable
Topic B: Analyse PivotTable Data

Lesson 5: Presenting Visual Insights with Dashboards in Excel

Topic A: Visualise Data with PivotCharts
Topic B: Filter Data Using Slicers and Timelines
Topic C: Create a Dashboard in Excel

Lesson 6: Automating Data Analysis with Excel

Topic A: Implement Data Validation, Forms, and Controls
Topic B: Adding Form Controls to a Worksheet
Topic C: Create Conditional Visualisations with Lookup Functions

Lesson 7: Creating Geospatial Visualisations with Excel

Topic A: Create Map Charts in Excel
Topic B: Customise Map Charts in Excel

Lesson 8: Performing Statistical Analysis with Excel

Topic A: Visualise Trendlines and Sparklines with Excel
Topic B: Analyse Data with the Data Analysis ToolPak
Topic C: Apply Best Practices in Chart Design

Lesson 9: Getting and Transforming Data

Topic A: Connect to Data with Queries
Topic B: Clean and Combine Data
Topic C: Shape and Transform Data

Lesson 10: Modelling Data with Power Pivot

Topic A: Install Power Pivot in Excel
Topic B: Create Data Models with Power Pivot
Topic C: Create Power Pivots

Lesson 11: Analysing Data with Power Pivot

Topic A: Data Analysis Expressions (DAX)
Topic B: Perform Advanced Data Analysis and Visualisation with DAX
Topic C: Create a Key Performance Indicator (KPI)
Topic D: Work with Dates and Times in PowerPivot

Lesson 12: Presenting Insights with Reports

Topic A: Plan a Report
Topic B: Create a Report

.

Data Analysis and Visualisation with Excel Advanced Course Objectives

Upon successful completion of this Data Analysis and Visualisation with Excel Advanced course, students will be able to:

• become familiar with the Power Pivot application and import data
• perform data analysis fundamentals
• visualise data with Excel
• analyse data with formulas and functions
• analyse data with PivotTables
• present visual insights with dashboards in Excel
• create geospatial visualisation with Excel
• perform statistical analysis
• get and transform data
• model and analyse data with Power Pivot
• present insights with reports.

.

Data Analysis and Visualisation with Excel Testimonials from our Website and Google Reviews

I was absolutely delighted with the Excel courses that Infero delivered which more than exceeded my expectation. I learnt new ways of using Excel that I can now use in my day to day work to make my work more efficient. Pivot tables were always a mystery to me but now I use them regularly to display HR and Payrol data.

Lisa Dunstan (Payroll Manager) from Decathlon UK

.

Had Excel training with Infero last week, I must say it was a good day, I am not the most gifted on excel, but after spending the day with our tutor Martin I came away with a lot more confidence and knowledge, and i will be back for more at a later date, Martin paced the course excellently so no one got left behind or not understanding how to do something. We had good rapport with Martin, even though he forgot how to spell his name :) must be an age thing Lol

Martin Pountney

.

I attended the level 3b training course offered by Infero Training and, like with many similar courses I have attended, was initially worried that it would be too much information to take in at once. However, the manuals and exercises provided along with the guidance and experience of our trainer Martin made the course interactive, concise and, dare i say it, enjoyable. I would highly recommend.

Michael Sexton

This Data Analysis and Visualisation with Excel Advanced course is designed for learners who already have foundational knowledge and skills in Excel and who wish to perform robust and advanced data and statistical analysis with Microsoft Excel using PivotTables, use tools such as Power Pivot and the Data Analysis ToolPak to analyse data, and visualise data and insights using advanced visualizations in charts and dashboards in Excel.

To ensure success in Data Analysis and Visualisation course with Excel Advanced, you should have baseline skill using Microsoft Excel worksheets, particularly in creating workbooks with formulas and functions. You can obtain this level of knowledge and skill by taking the following or any similar equivalent course:

• Microsoft Excel Introduction

Being proficient in Data Analysis and Visualisation with Excel Advanced you can open the door to many career opportunities such as:

• Administrative Assistant
• Data Analyst
• Accountants
• Financial Analyst
• Retail Store Manager
• Project Manager
• Business Analyst

Certificate of completion

Digital certificate - Included